package com.tyut.mapper;


import com.tyut.pojo.Category;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface CategoryMapper {
	//添加分类
	@Insert("insert into category(category_name, category_alias, create_user, create_time, update_time) VALUES  (#{categoryName}, #{categoryAlias}, #{createUser}, #{createTime}, #{updateTime})")
	void add(Category category);

	//查询分类
	@Select("select * from category where create_user = #{id}")
	List<Category> find(Integer id);

	//查询分类详情
	@Select("select * from category where id = #{id}")
	Category findById(Integer id);
	//修改分类
	@Update("update category set category_name=#{categoryName},category_alias=#{categoryAlias},update_time=#{updateTime} where id=#{id}")
	void update(Category category);
	//删除分类
	@Delete("delete from category where id = #{id}")
	void delete(Integer id);
	@Select("select * from category where create_user in (#{id},#{i})")
	List<Category> findAll(Integer id, int i);
}
